PHP Excel

PHP Excel, Reading an Excel File in Php

PHP Excel Reader - Google Code

PHP Excel Reader - Parse and retrieve information from XLS files

This PHP library expands on the great work done in the PHP Excel Reader project on SourceForge.

It reads the binary format of XLS files directly and can return values and formats from any cell.

Download

http://code.google.com/p/php-excel-reader/downloads/list

Example

Microsoft Excel Screenshot

PHP Output

By simply using this php command:

dump(true,true); ?>

The output looks like this (with some CSS):

More about PHP Vs Excel

PHPExcel - OpenXML - Read, Write Excel in PHP

PHPExcel - OpenXML

PHP - Spreadsheet engine - Parse and retrieve information from XLS files

Project providing a set of classes for the PHP programming language, which allow you to write to and read from different spreadsheet file formats, like Excel (BIFF) .xls, Excel 2007 (OfficeOpenXML) .xlsx, CSV, Libre/OpenOffice Calc .ods, Gnumeric, PDF, HTML, ... This project is built around Microsoft's OpenXML standard and PHP. Checkout the Features this class set provides, such as setting spreadsheet meta data (author, title, description, ...), multiple worksheets, different fonts and font styles, cell borders, fills, gradients, adding images to your spreadsheet, calculating formulas, converting between file types and much, much more!

Download PHPExcel 1.8.0

All code is now maintained on github
Last release here on codeplex: PHPExcel 1.8.0
https://phpexcel.codeplex.com/releases/view/119187

Requirements

PHP version 5.2.0 or higher
PHP extension php_zip enabled *)
PHP extension php_xml enabled
PHP extension php_gd2 enabled (if not compiled in)
All part of the PHP package (zip) on http://www.php.net/downloads.php, should be enabled in php.ini

*) php_zip is only needed by PHPExcel_Reader_Excel2007, PHPExcel_Writer_Excel2007, PHPExcel_Reader_OOCalc. In other words, if you need PHPExcel to handle .xlsx or .ods files you will need the zip extension, but otherwise not.